package com.cqu.lpss.mapper;

import com.cqu.lpss.pojo.Professors;
import org.apache.ibatis.annotations.Mapper;

import java.sql.Date;
import java.util.List;

@Mapper
public interface ProfessorsMapper {
    public Professors findByIdAndPassword(String proId,String proPassword);
    public Professors findById(String proId);
    public List<Professors> list(String proId, String proName, Integer proLowAge, Integer proHighAge, Integer proGender, String proEmail, String proPhone, Integer proAuth, Integer proClass);
    public int delete(Integer deleteproIndex);
    public Professors findByIndex(Integer proIndex);
    public int inserte(
            String  proId,
            String  proName,
            Integer proAge,
            Integer proGender,
            String  proEmail,
            String  proPassword,
            String  proPhone,
            Integer proAuth,
            Integer proClass,
            java.sql.Date proBirth,
            java.sql.Timestamp proCreatetime,
            java.sql.Timestamp proUpdatetime);
    public int update(Integer proIndex,String proName,String proEmail,String proPassword,String proPhone,Integer proClass,Integer proAuth,java.sql.Timestamp proUpdatetime);
    public Professors findByPhone(String phone);
    public  List<Professors> select_All(Integer proAuth);
    public int PersonCenter_upload(String newpassword,String phone,String email,String Id);
}
